<?php
/**
 * WordPress DB Class
 *
 * Original code from {@link http://php.justinvincent.com Justin Vincent (justin@visunet.ie)}
 *
 * @package WordPress
 * @subpackage Database
 * @since 0.71
 */

require_once dirname(dirname(__FILE__)) . 
    DIRECTORY_SEPARATOR . 'translations' . 
    DIRECTORY_SEPARATOR . 'sqlsrv' . 
    DIRECTORY_SEPARATOR . 'translations.php';

/**
 * WordPress Database Access Abstraction Object
 *
 * It is possible to replace this class with your own
 * by setting the $wpdb global variable in wp-content/db.php
 * file with your class. You can name it wpdb also, since
 * this file will not be included, if the other file is
 * available.
 *
 * @link http://codex.wordpress.org/Function_Reference/wpdb_Class
 *
 * @package WordPress
 * @subpackage Database
 * @since 0.71
 * @final
 */
class sqlsrv_wpdb extends SQL_Translations {

    /**
     * Whether to show SQL/DB errors
     *
     * @since 0.71
     * @access private
     * @var bool
     */
    var $show_errors = false;

    /**
     * Whether to suppress errors during the DB bootstrapping.
     *
     * @access private
     * @since 2.5
     * @var bool
     */
    var $suppress_errors = false;

    /**
     * The last error during query.
     *
     * @see get_last_error()
     * @since 2.5
     * @access private
     * @var string
     */
    var $last_error = '';

    /**
     * Amount of queries made
     *
     * @since 1.2.0
     * @access private
     * @var int
     */
    var $num_queries = 0;

    /**
     * Count of rows returned by previous query
     *
     * @since 1.2
     * @access private
     * @var int
     */
    var $num_rows = 0;

    /**
     * Count of affected rows by previous query
     *
     * @since 0.71
     * @access private
     * @var int
     */
    var $rows_affected = 0;

    /**
     * The ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT).
     *
     * @since 0.71
     * @access public
     * @var int
     */
    var $insert_id = 0;

    /**
     * Saved result of the last query made
     *
     * @since 1.2.0
     * @access private
     * @var array
     */
    var $last_query;

    /**
     * Results of the last query made
     *
     * @since 1.0.0
     * @access private
     * @var array|null
     */
    var $last_result;

    /**
     * Saved info on the table column
     *
     * @since 1.2.0
     * @access private
     * @var array
     */
    var $col_info;

    /**
     * Saved queries that were executed
     *
     * @since 1.5.0
     * @access private
     * @var array
     */
    var $queries;

    /**
     * WordPress table prefix
     *
     * You can set this to have multiple WordPress installations
     * in a single database. The second reason is for possible
     * security precautions.
     *
     * @since 0.71
     * @access private
     * @var string
     */
    var $prefix = '';

    /**
     * Whether the database queries are ready to start executing.
     *
     * @since 2.5.0
     * @access private
     * @var bool
     */
    var $ready = false;

    /**
     * {@internal Missing Description}}
     *
     * @since 3.0.0
     * @access public
     * @var int
     */
    var $blogid = 0;

    /**
     * {@internal Missing Description}}
     *
     * @since 3.0.0
     * @access public
     * @var int
     */
    var $siteid = 0;

    /**
     * List of WordPress per-blog tables
     *
     * @since 2.5.0
     * @access private
     * @see wpdb::tables()
     * @var array
     */
    var $tables = array( 'posts', 'comments', 'links', 'options', 'postmeta',
        'terms', 'term_taxonomy', 'term_relationships', 'commentmeta' );

    /**
     * List of deprecated WordPress tables
     *
     * categories, post2cat, and link2cat were deprecated in 2.3.0, db version 5539
     *
     * @since 2.9.0
     * @access private
     * @see wpdb::tables()
     * @var array
     */
    var $old_tables = array( 'categories', 'post2cat', 'link2cat' );

    /**
     * List of WordPress global tables
     *
     * @since 3.0.0
     * @access private
     * @see wpdb::tables()
     * @var array
     */
    var $global_tables = array( 'users', 'usermeta' );

    /**
     * List of Multisite global tables
     *
     * @since 3.0.0
     * @access private
     * @see wpdb::tables()
     * @var array
     */
    var $ms_global_tables = array( 'blogs', 'signups', 'site', 'sitemeta',
        'sitecategories', 'registration_log', 'blog_versions' );

    /**
     * WordPress Comments table
     *
     * @since 1.5.0
     * @access public
     * @var string
     */
    var $comments;

    /**
     * WordPress Comment Metadata table
     *
     * @since 2.9.0
     * @access public
     * @var string
     */
    var $commentmeta;

    /**
     * WordPress Links table
     *
     * @since 1.5.0
     * @access public
     * @var string
     */
    var $links;

    /**
     * WordPress Options table
     *
     * @since 1.5.0
     * @access public
     * @var string
     */
    var $options;

    /**
     * WordPress Post Metadata table
     *
     * @since 1.5.0
     * @access public
     * @var string
     */
    var $postmeta;

    /**
     * WordPress Posts table
     *
     * @since 1.5.0
     * @access public
     * @var string
     */
    var $posts;

    /**
     * WordPress Terms table
     *
     * @since 2.3.0
     * @access public
     * @var string
     */
    var $terms;

    /**
     * WordPress Term Relationships table
     *
     * @since 2.3.0
     * @access public
     * @var string
     */
    var $term_relationships;

    /**
     * WordPress Term Taxonomy table
     *
     * @since 2.3.0
     * @access public
     * @var string
     */
    var $term_taxonomy;

    /*
     * Global and Multisite tables
     */

    /**
     * WordPress User Metadata table
     *
     * @since 2.3.0
     * @access public
     * @var string
     */
    var $usermeta;

    /**
     * WordPress Users table
     *
     * @since 1.5.0
     * @access public
     * @var string
     */
    var $users;

    /**
     * Multisite Blogs table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $blogs;

    /**
     * Multisite Blog Versions table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $blog_versions;

    /**
     * Multisite Registration Log table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $registration_log;

    /**
     * Multisite Signups table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $signups;

    /**
     * Multisite Sites table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $site;

    /**
     * Multisite Sitewide Terms table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $sitecategories;

    /**
     * Multisite Site Metadata table
     *
     * @since 3.0.0
     * @access public
     * @var string
     */
    var $sitemeta;

    /**
     * Format specifiers for DB columns. Columns not listed here default to %s. Initialized during WP load.
     *
     * Keys are column names, values are format types: 'ID' => '%d'
     *
     * @since 2.8.0
     * @see wpdb:prepare()
     * @see wpdb:insert()
     * @see wpdb:update()
     * @see wp_set_wpdb_vars()
     * @access public
     * @var array
     */
    var $field_types = array();

    /**
     * Database table columns charset
     *
     * @since 2.2.0
     * @access public
     * @var string
     */
    var $charset;

    /**
     * Database table columns collate
     *
     * @since 2.2.0
     * @access public
     * @var string
     */
    var $collate;

    /**
     * Whether to use mysql_real_escape_string
     *
     * @since 2.8.0
     * @access public
     * @var bool
     */
    var $real_escape = false;

    /**
     * Database Username
     *
     * @since 2.9.0
     * @access private
     * @var string
     */
    var $dbuser;

    /**
     * A textual description of the last query/get_row/get_var call
     *
     * @since unknown
     * @access public
     * @var string
     */
    var $func_call;
    
    /**
     * Saved result of the last translated query made
     *
     * @since 1.2.0
     * @access private
     * @var array
     */
    var $previous_query;
    
    /**
    * Database type
    *
    * @access public
    * @var string
    */
    var $db_type;

    /**
     * Connects to the database server and selects a database
     *
     * PHP4 compatibility layer for calling the PHP5 constructor.
     *
     * @uses wpdb::__construct() Passes parameters and returns result
     * @since 0.71
     *
     * @param string $dbuser MySQL database user
     * @param string $dbpassword MySQL database password
     * @param string $dbname MySQL database name
     * @param string $dbhost MySQL database host
     */
    function wpdb( $dbuser, $dbpassword, $dbname, $dbhost ) {
        if( defined( 'WP_USE_MULTIPLE_DB' ) && WP_USE_MULTIPLE_DB )
            $this->db_connect();
        return $this->__construct( $dbuser, $dbpassword, $dbname, $dbhost );
    }

    /**
     * Connects to the database server and selects a database
     *
     * PHP5 style constructor for compatibility with PHP5. Does
     * the actual setting up of the class properties and connection
     * to the database.
     *
     * @link http://core.trac.wordpress.org/ticket/3354
     * @since 2.0.8
     *
     * @param string $dbuser MySQL database user
     * @param string $dbpassword MySQL database password
     * @param string $dbname MySQL database name
     * @param string $dbhost MySQL database host
     */
    function __construct( $dbuser, $dbpassword, $dbname, $dbhost ) {
        register_shutdown_function( array( &$this, '__destruct' ) );

        if ( WP_DEBUG )
            $this->show_errors();

        if ( is_multisite() ) {
            $this->charset = 'utf8';
            if ( defined( 'DB_COLLATE' ) && DB_COLLATE )
                $this->collate = DB_COLLATE;
            else
                $this->collate = 'utf8_general_ci';
        } elseif ( defined( 'DB_COLLATE' ) ) {
            $this->collate = DB_COLLATE;
        }

        if ( defined( 'DB_CHARSET' ) )
            $this->charset = DB_CHARSET;

        parent::__construct();
        
        $this->db_type = DB_TYPE;

        $this->dbuser = $dbuser;
        
        /* Specify the server and connection string attributes. */
        $connection_info = array(
            'UID' => $dbuser,
            'PWD' => $dbpassword,
            'Database' => $dbname,
            'CharacterSet' => 'UTF-8',
        );
        
        // Is this SQL Azure?
        if (stristr($dbhost, 'database.windows.net') !== false) {
            // Need to turn off MultipleActiveResultSets, this requires
            // Sql Server Driver for PHP 1.1 (1.0 doesn't support this property)
            $connection_info['MultipleActiveResultSets'] = false; 
            $this->azure = true;
        }

        $this->dbh = sqlsrv_connect( $dbhost, $connection_info);
        sqlsrv_configure('WarningsReturnAsErrors', 0);

        if ( !$this->dbh ) {
            $this->bail( sprintf( /*WP_I18N_DB_CONN_ERROR*/"
<h1>Error establishing a database connection</h1>
<p>This either means that the username and password information in your <code>wp-config.php</code> file is incorrect or we can't contact the database server at <code>%s</code>. This could mean your host's database server is down.</p>
<ul>
    <li>Are you sure you have the correct username and password?</li>
    <li>Are you sure that you have typed the correct hostname?</li>
    <li>Are you sure that the database server is running?</li>
</ul>
<p>If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the <a href='http://wordpress.org/support/'>WordPress Support Forums</a>.</p>
"/*/WP_I18N_DB_CONN_ERROR*/, $dbhost ), 'db_connect_fail' );
            return;
        }

        $this->ready = true;

        // Make sure textsize fields are set to max.
        @sqlsrv_query('SET TEXTSIZE 2147483647');
        // SET NAMES doesn't translate
        /*
        if ( $this->has_cap( 'collation' ) && !empty( $this->charset ) ) {
            if ( function_exists( 'mysql_set_charset' ) ) {
                mysql_set_charset( $this->charset, $this->dbh );
                $this->real_escape = true;
            } else {
                $query = $this->prepare( 'SET NAMES %s', $this->charset );
                if ( ! empty( $this->collate ) )
                    $query .= $this->prepare( ' COLLATE %s', $this->collate );
                $this->query( $query );
            }
        }
        */

        $this->select( $dbname, $this->dbh );
    }

    /**
     * PHP5 style destructor and will run when database object is destroyed.
     *
     * @see wpdb::__construct()
     * @since 2.0.8
     * @return bool true
     */
    function __destruct() {
        return true;
    }

    /**
     * Sets the table prefix for the WordPress tables.
     *
     * @since 2.5.0
     *
     * @param string $prefix Alphanumeric name for the new prefix.
     * @return string|WP_Error Old prefix or WP_Error on error
     */
    function set_prefix( $prefix, $set_table_names = true ) {

        if ( preg_match( '|[^a-z0-9_]|i', $prefix ) )
            return new WP_Error('invalid_db_prefix', /*WP_I18N_DB_BAD_PREFIX*/'Invalid database prefix'/*/WP_I18N_DB_BAD_PREFIX*/);

        $old_prefix = is_multisite() ? '' : $prefix;

        if ( isset( $this->base_prefix ) )
            $old_prefix = $this->base_prefix;

        $this->base_prefix = $prefix;

        if ( $set_table_names ) {
            foreach ( $this->tables( 'global' ) as $table => $prefixed_table )
                $this->$table = $prefixed_table;

            if ( is_multisite() && empty( $this->blogid ) )
                return $old_prefix;

            $this->prefix = $this->get_blog_prefix();

            foreach ( $this->tables( 'blog' ) as $table => $prefixed_table )
                $this->$table = $prefixed_table;

            foreach ( $this->tables( 'old' ) as $table => $prefixed_table )
                $this->$table = $prefixed_table;
        }
        return $old_prefix;
    }

    /**
     * Sets blog id.
     *
     * @since 3.0.0
     * @access public
     * @param int $blog_id
     * @param int $site_id Optional.
     * @return string previous blog id
     */
    function set_blog_id( $blog_id, $site_id = 0 ) {
        if ( ! empty( $site_id ) )
            $this->siteid = $site_id;

        $old_blog_id  = $this->blogid;
        $this->blogid = $blog_id;

        $this->prefix = $this->get_blog_prefix();

        foreach ( $this->tables( 'blog' ) as $table => $prefixed_table )
            $this->$table = $prefixed_table;

        foreach ( $this->tables( 'old' ) as $table => $prefixed_table )
            $this->$table = $prefixed_table;

        return $old_blog_id;
    }

    /**
     * Gets blog prefix.
     *
     * @uses is_multisite()
     * @since 3.0.0
     * @param int $blog_id Optional.
     * @return string Blog prefix.
     */
    function get_blog_prefix( $blog_id = null ) {
        if ( is_multisite() ) {
            if ( null === $blog_id )
                $blog_id = $this->blogid;
            if ( defined( 'MULTISITE' ) && ( 0 == $blog_id || 1 == $blog_id ) )
                return $this->base_prefix;
            else
                return $this->base_prefix . $blog_id . '_';
        } else {
            return $this->base_prefix;
        }
    }

    /**
     * Returns an array of WordPress tables.
     *
     * Also allows for the CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE to
     * override the WordPress users and usersmeta tables that would otherwise
     * be determined by the prefix.
     *
     * The scope argument can take one of the following:
     *
     * 'all' - returns 'all' and 'global' tables. No old tables are returned.
     * 'blog' - returns the blog-level tables for the queried blog.
     * 'global' - returns the global tables for the installation, returning multisite tables only if running multisite.
     * 'ms_global' - returns the multisite global tables, regardless if current installation is multisite.
     * 'old' - returns tables which are deprecated.
     *
     * @since 3.0.0
     * @uses wpdb::$tables
     * @uses wpdb::$old_tables
     * @uses wpdb::$global_tables
     * @uses wpdb::$ms_global_tables
     * @uses is_multisite()
     *
     * @param string $scope Optional. Can be all, global, ms_global, blog, or old tables. Defaults to all.
     * @param bool $prefix Optional. Whether to include table prefixes. Default true. If blog
     *  prefix is requested, then the custom users and usermeta tables will be mapped.
     * @param int $blog_id Optional. The blog_id to prefix. Defaults to wpdb::$blogid. Used only when prefix is requested.
     * @return array Table names. When a prefix is requested, the key is the unprefixed table name.
     */
    function tables( $scope = 'all', $prefix = true, $blog_id = 0 ) {
        switch ( $scope ) {
            case 'all' :
                $tables = array_merge( $this->global_tables, $this->tables );
                if ( is_multisite() )
                    $tables = array_merge( $tables, $this->ms_global_tables );
                break;
            case 'blog' :
                $tables = $this->tables;
                break;
            case 'global' :
                $tables = $this->global_tables;
                if ( is_multisite() )
                    $tables = array_merge( $tables, $this->ms_global_tables );
                break;
            case 'ms_global' :
                $tables = $this->ms_global_tables;
                break;
            case 'old' :
                $tables = $this->old_tables;
                break;
            default :
                return array();
                break;
        }

        if ( $prefix ) {
            if ( ! $blog_id )
                $blog_id = $this->blogid;
            $blog_prefix = $this->get_blog_prefix( $blog_id );
            $base_prefix = $this->base_prefix;
            $global_tables = array_merge( $this->global_tables, $this->ms_global_tables );
            foreach ( $tables as $k => $table ) {
                if ( in_array( $table, $global_tables ) )
                    $tables[ $table ] = $base_prefix . $table;
                else
                    $tables[ $table ] = $blog_prefix . $table;
                unset( $tables[ $k ] );
            }

            if ( isset( $tables['users'] ) && defined( 'CUSTOM_USER_TABLE' ) )
                $tables['users'] = CUSTOM_USER_TABLE;

            if ( isset( $tables['usermeta'] ) && defined( 'CUSTOM_USER_META_TABLE' ) )
                $tables['usermeta'] = CUSTOM_USER_META_TABLE;
        }

        return $tables;
    }

    /**
     * Selects a database using the current database connection.
     *
     * The database name will be changed based on the current database
     * connection. On failure, the execution will bail and display an DB error.
     *
     * @since 0.71
     *
     * @param string $db MySQL database name
     * @return null Always null.
     */
    function select( $db, &$dbh ) {
        $result = $dbh;
        if ( !$result ) {
            $this->ready = false;
            $this->bail( sprintf( /*WP_I18N_DB_SELECT_DB*/'
<h1>Can&#8217;t select database</h1>
<p>We were able to connect to the database server (which means your username and password is okay) but not able to select the <code>%1$s</code> database.</p>
<ul>
<li>Are you sure it exists?</li>
<li>Does the user <code>%2$s</code> have permission to use the <code>%1$s</code> database?</li>
<li>On some systems the name of your database is prefixed with your username, so it would be like <code>username_%1$s</code>. Could that be the problem?</li>
</ul>
<p>If you don\'t know how to set up a database you should <strong>contact your host</strong>. If all else fails you may find help at the <a href="http://wordpress.org/support/">WordPress Support Forums</a>.</p>'/*/WP_I18N_DB_SELECT_DB*/, $db, $this->dbuser ), 'db_select_fail' );
            return;
        }
    }

    /**
     * Weak escape, using addslashes()
     *
     * @see addslashes()
     * @since 2.8.0
     * @access private
     *
     * @param string $string
     * @return string
     */
    function _weak_escape( $string ) {
        return str_replace("'", "''", $string);
    }

    /**
     * Real escape, using mysql_real_escape_string() or addslashes()
     *
     * @see mysql_real_escape_string()
     * @see addslashes()
     * @since 2.8
     * @access private
     *
     * @param  string $string to escape
     * @return string escaped
     */
    function _real_escape( $string ) {
        return str_replace("'", "''", $string);
    }

    /**
     * Escape data. Works on arrays.
     *
     * @uses wpdb::_escape()
     * @uses wpdb::_real_escape()
     * @since  2.8
     * @access private
     *
     * @param  string|array $data
     * @return string|array escaped
     */
    function _escape( $data ) {
        if ( is_array( $data ) ) {
            foreach ( (array) $data as $k => $v ) {
                if ( is_array($v) )
                    $data[$k] = $this->_escape( $v );
                else
                    $data[$k] = $this->_real_escape( $v );
            }
        } else {
            $data = $this->_real_escape( $data );
        }

        return $data;
    }

    /**
     * Escapes content for insertion into the database using addslashes(), for security.
     *
     * Works on arrays.
     *
     * @since 0.71
     * @param string|array $data to escape
     * @return string|array escaped as query safe string
     */
    function escape( $data ) {
        if ( is_array( $data ) ) {
            foreach ( (array) $data as $k => $v ) {
                if ( is_array( $v ) )
                    $data[$k] = $this->escape( $v );
                else
                    $data[$k] = $this->_weak_escape( $v );
            }
        } else {
            $data = $this->_weak_escape( $data );
        }

        return $data;
    }

    /**
     * Escapes content by reference for insertion into the database, for security
     *
     * @uses wpdb::_real_escape()
     * @since 2.3.0
     * @param string $string to escape
     * @return void
     */
    function escape_by_ref( &$string ) {
        $string = $this->_real_escape( $string );
    }

    /**
     * Prepares a SQL query for safe execution. Uses sprintf()-like syntax.
     *
     * The following directives can be used in the query format string:
     *   %d (decimal number)
     *   %s (string)
     *   %% (literal percentage sign - no argument needed)
     *
     * Both %d and %s are to be left unquoted in the query string and they need an argument passed for them.
     * Literals (%) as parts of the query must be properly written as %%.
     *
     * This function only supports a small subset of the sprintf syntax; it only supports %d (decimal number), %s (string).
     * Does not support sign, padding, alignment, width or precision specifiers.
     * Does not support argument numbering/swapping.
     *
     * May be called like {@link http://php.net/sprintf sprintf()} or like {@link http://php.net/vsprintf vsprintf()}.
     *
     * Both %d and %s should be left unquoted in the query string.
     *
     * <code>
     * wpdb::prepare( "SELECT * FROM `table` WHERE `column` = %s AND `field` = %d", 'foo', 1337 )
     * wpdb::prepare( "SELECT DATE_FORMAT(`field`, '%%c') FROM `table` WHERE `column` = %s", 'foo' );
     * </code>
     *
     * @link http://php.net/sprintf Description of syntax.
     * @since 2.3.0
     *
     * @param string $query Query statement with sprintf()-like placeholders
     * @param array|mixed $args The array of variables to substitute into the query's placeholders if being called like
     *  {@link http://php.net/vsprintf vsprintf()}, or the first variable to substitute into the query's placeholders if
     *  being called like {@link http://php.net/sprintf sprintf()}.
     * @param mixed $args,... further variables to substitute into the query's placeholders if being called like
     *  {@link http://php.net/sprintf sprintf()}.
     * @return null|false|string Sanitized query string, null if there is no query, false if there is an error and string
     *  if there was something to prepare
     */
    function prepare( $query = null ) { // ( $query, *$args )
        if ( is_null( $query ) ) {
            return;
        }
        $this->prepare_args = func_get_args();
        array_shift($this->prepare_args);
        // If args were passed as an array (as in vsprintf), move them up
        if ( isset($this->prepare_args[0]) && is_array($this->prepare_args[0]) ) {
            $this->prepare_args = $this->prepare_args[0];
        }
        $flag = '--PREPARE';
        foreach($this->prepare_args as $key => $arg){
            if (is_serialized($arg)) {
                $flag = '--SERIALIZED';
            }
        }
        $query = str_replace("'%s'", '%s', $query); // in case someone mistakenly already singlequoted it
        $query = str_replace('"%s"', '%s', $query); // doublequote unquoting
        $query = preg_replace( '|(?<!%)%s|', "'%s'", $query ); // quote the strings, avoiding escaped strings like %%s
        array_walk($this->prepare_args, array(&$this, 'escape_by_ref'));
        return @vsprintf($query, $this->prepare_args).$flag;
    }

    /**
     * Print SQL/DB error.
     *
     * @since 0.71
     * @global array $EZSQL_ERROR Stores error information of query and error string
     *
     * @param string $str The error to display
     * @return bool False if the showing of errors is disabled.
     */
    function print_error( $str = '' ) {
        global $EZSQL_ERROR;

        if ( !$str )
            $str = sqlsrv_errors(SQLSRV_ERR_ERRORS);
            $str = $str[0]['message'];
        $EZSQL_ERROR[] = array( 'query' => $this->previous_query, 'error_str' => $str );

        if ( $this->suppress_errors )
            return false;

        if ( $caller = $this->get_caller() )
            $error_str = sprintf( /*WP_I18N_DB_QUERY_ERROR_FULL*/'WordPress database error %1$s for query %2$s made by %3$s'/*/WP_I18N_DB_QUERY_ERROR_FULL*/, $str, $this->previous_query, $caller );
        else
            $error_str = sprintf( /*WP_I18N_DB_QUERY_ERROR*/'WordPress database error %1$s for query %2$s'/*/WP_I18N_DB_QUERY_ERROR*/, $str, $this->previous_query );

        if ( function_exists( 'error_log' )
            && ( $log_file = @ini_get( 'error_log' ) )
            && ( 'syslog' == $log_file || @is_writable( $log_file ) )
            )
            @error_log( $error_str );

        // Are we showing errors?
        if ( ! $this->show_errors )
            return false;

        // If there is an error then take note of it
        if ( is_multisite() ) {
            $msg = "WordPress database error: [$str]\n{$this->previous_query}\n";
            if ( defined( 'ERRORLOGFILE' ) )
                error_log( $msg, 3, ERRORLOGFILE );
            if ( defined( 'DIEONDBERROR' ) )
                wp_die( $msg );
        } else {
            $str   = htmlspecialchars( $str, ENT_QUOTES );
            $query = htmlspecialchars( $this->previous_query, ENT_QUOTES );

            print "<div id='error'>
            <p class='wpdberror'><strong>WordPress database error:</strong> [$str]<br />
            <code>$query</code></p>
            </div>";
        }
    }

    /**
     * Enables showing of database errors.
     *
     * This function should be used only to enable showing of errors.
     * wpdb::hide_errors() should be used instead for hiding of errors. However,
     * this function can be used to enable and disable showing of database
     * errors.
     *
     * @since 0.71
     * @see wpdb::hide_errors()
     *
     * @param bool $show Whether to show or hide errors
     * @return bool Old value for showing errors.
     */
    function show_errors( $show = true ) {
        $errors = $this->show_errors;
        $this->show_errors = $show;
        return $errors;
    }

    /**
     * Disables showing of database errors.
     *
     * By default database errors are not shown.
     *
     * @since 0.71
     * @see wpdb::show_errors()
     *
     * @return bool Whether showing of errors was active
     */
    function hide_errors() {
        $show = $this->show_errors;
        $this->show_errors = false;
        return $show;
    }

    /**
     * Whether to suppress database errors.
     *
     * By default database errors are suppressed, with a simple
     * call to this function they can be enabled.
     *
     * @since 2.5
     * @see wpdb::hide_errors()
     * @param bool $suppress Optional. New value. Defaults to true.
     * @return bool Old value
     */
    function suppress_errors( $suppress = true ) {
        $errors = $this->suppress_errors;
        $this->suppress_errors = (bool) $suppress;
        return $errors;
    }

    /**
     * Kill cached query results.
     *
     * @since 0.71
     * @return void
     */
    function flush() {
        $this->last_result = array();
        $this->col_info    = null;
        $this->last_query  = null;
    }

    function db_connect( $query = "SELECT" ) {
        global $db_list, $global_db_list;
        if ( ! is_array( $db_list ) )
            return true;

        if ( $this->blogs != '' && preg_match("/(" . $this->blogs . "|" . $this->users . "|" . $this->usermeta . "|" . $this->site . "|" . $this->sitemeta . "|" . $this->sitecategories . ")/i",$query) ) {
            $action = 'global';
            $details = $global_db_list[ mt_rand( 0, count( $global_db_list ) -1 ) ];
            $this->db_global = $details;
        } elseif ( preg_match("/^\\s*(alter table|create|insert|delete|update|replace) /i",$query) ) {
            $action = 'write';
            $details = $db_list[ 'write' ][ mt_rand( 0, count( $db_list[ 'write' ] ) -1 ) ];
            $this->db_write = $details;
        } else {
            $action = '';
            $details = $db_list[ 'read' ][ mt_rand( 0, count( $db_list[ 'read' ] ) -1 ) ];
            $this->db_read = $details;
        }

        $dbhname = "dbh" . $action;
        
        if (get_magic_quotes_gpc()) {
            $details[ 'db_host' ] = trim(str_replace("\\\\", "\\", $details[ 'db_host' ]));
        }

        /* Specify the server and connection string attributes. */
        $connection_info = array(
            'UID' => $details[ 'db_user' ],
            'PWD' => $details[ 'db_password' ],
            'Database' => $details[ 'db_name' ],
            'CharacterSet' => 'UTF-8',
        );
        
        // Is this SQL Azure?
        if (stristr($details[ 'db_host' ], 'database.windows.net') !== false) {
            // Need to turn off MultipleActiveResultSets, this requires
            // Sql Server Driver for PHP 1.1 (1.0 doesn't support this property)
            $connection_info['MultipleActiveResultSets'] = false; 
            $this->azure = true;
        }

        $this->$dbhname = sqlsrv_connect( $details[ 'db_host' ], $connection_info );

        if (!$this->$dbhname ) {
            $this->bail( sprintf( /*WP_I18N_DB_CONN_ERROR*/"
<h1>Error establishing a database connection</h1>
<p>This either means that the username and password information in your <code>wp-config.php</code> file is incorrect or we can't contact the database server at <code>%s</code>. This could mean your host's database server is down.</p>
<ul>
    <li>Are you sure you have the correct username and password?</li>
    <li>Are you sure that you have typed the correct hostname?</li>
    <li>Are you sure that the database server is running?</li>
</ul>
<p>If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the <a href='http://wordpress.org/support/'>WordPress Support Forums</a>.</p>
"/*/WP_I18N_DB_CONN_ERROR*/, $details['db_host'] ), 'db_connect_fail' );
        }
        
        // Make sure textsize fields are set to max.
        @sqlsrv_query('SET TEXTSIZE 2147483647');
        
        $this->select( $details[ 'db_name' ], $this->$dbhname );
    }

    /**
     * Perform a MySQL database query, using current database connection.
     *
     * More information can be found on the codex page.
     *
     * @since 0.71
     *
     * @param string $query Database query
     * @return int|false Number of rows affected/selected or false on error
     */
    function query( $query, $translate = true ) {
        if ( ! $this->ready )
            return false;

        // some queries are made before the plugins have been loaded, and thus cannot be filtered with this method
        if ( function_exists( 'apply_filters' ) )
            $query = apply_filters( 'query', $query );

        $return_val = 0;
        $this->flush();

        // Log how the function was called
        $this->func_call = "\$db->query(\"$query\")";

        // Keep track of the last query for debug..
        $this->last_query = $query;

        // use $this->dbh for read ops, and $this->dbhwrite for write ops
        // use $this->dbhglobal for gloal table ops
        unset( $dbh );
        if( defined( 'WP_USE_MULTIPLE_DB' ) && WP_USE_MULTIPLE_DB ) {
            if( $this->blogs != '' && preg_match("/(" . $this->blogs . "|" . $this->users . "|" . $this->usermeta . "|" . $this->site . "|" . $this->sitemeta . "|" . $this->sitecategories . ")/i",$query) ) {
                if( false == isset( $this->dbhglobal ) ) {
                    $this->db_connect( $query );
                }
                $dbh =& $this->dbhglobal;
                $this->last_db_used = "global";
            } elseif ( preg_match("/^\\s*(alter table|create|insert|delete|update|replace) /i",$query) ) {
                if( false == isset( $this->dbhwrite ) ) {
                    $this->db_connect( $query );
                }
                $dbh =& $this->dbhwrite;
                $this->last_db_used = "write";
            } else {
                $dbh =& $this->dbh;
                $this->last_db_used = "read";
            }
        } else {
            $dbh =& $this->dbh;
            $this->last_db_used = "other/read";
        }

        // Make Necessary Translations
        if ($translate === true) {
            $query = $this->translate($query);
            $this->previous_query = $query;
        }
        
        if ($this->preceeding_query !== false) {
            if (is_array($this->preceeding_query)) {
                foreach ($this->preceeding_query as $p_query) {
                    @sqlsrv_query($dbh, $p_query);
                }
            } else {
                @sqlsrv_query($dbh, $this->preceeding_query);
            }
            $this->preceeding_query = false;
        }
        
        // Check if array of queries (this happens for INSERTS with multiple VALUES blocks)
        if (is_array($query)) {
            foreach ($query as $sub_query) {
                $this->_pre_query();
                $this->result = @sqlsrv_query($dbh, $sub_query);
                $return_val = $this->_post_query($dbh, $sub_query);
            }
        } else {
            $this->_pre_query();
            $this->result = @sqlsrv_query($dbh, $query);
            $return_val = $this->_post_query($dbh, $query);
        }
        
        if ($this->following_query !== false) {
            if (is_array($this->following_query)) {
                foreach ($this->following_query as $f_query) {
                    @sqlsrv_query($dbh, $f_query);
                }
            } else {
                @sqlsrv_query($dbh, $this->following_query);
            }
            $this->following_query = false;
        }

        return $return_val;
    }
    
    function _pre_query() {
        if ( defined('SAVEQUERIES') && SAVEQUERIES ) {
            $this->timer_start();
        }
    } 
    
    function _post_query($dbh, $query) {
        ++$this->num_queries;

        if ( defined('SAVEQUERIES') && SAVEQUERIES ) {
            $this->queries[] = array( $query, $this->timer_stop(), $this->get_caller() );
        }
        
        // If there is an error then take note of it..
        if ( $this->result == FALSE ) {
            $this->last_error = sqlsrv_errors(SQLSRV_ERR_ALL);
            if ($this->last_error != '') {
                $this->log_query($this->last_error);
                //echo "<pre>";
                //var_dump($query);
                //var_dump($this->translation_changes);
                //echo "</pre>";
                $this->print_error();
            }
            return false;
        }
        
        if ( preg_match("/^\\s*(insert|delete|update|replace) /i",$query) ) {
            $this->rows_affected = sqlsrv_rows_affected($this->result);

            // Take note of the insert_id
            if ( preg_match("/^\\s*(insert|replace) /i",$query) ) {
                $result = @sqlsrv_fetch_object(@sqlsrv_query($dbh, "SELECT SCOPE_IDENTITY() AS ID"));
                $this->insert_id = $result->ID;
            }

            $return_val = $this->rows_affected;
        } else {

            $i = 0;
            while ($i < @sqlsrv_num_fields($this->result)) {
                $field = @sqlsrv_field_metadata($this->result);
                if ($field[0]['Type'] == -1) {
                    $type = 'text';
                } elseif ($field[0]['Type'] == 12) {
                    $type = 'char';
                } elseif ($field[0]['Type'] == -5) {
                    $type = 'numeric';
                } else {
                    $type = $field[0]['Type'];
                }
                $new_field = new stdClass();
                $new_field->name = $field[0]['Name'];
                $new_field->table = $field[0]['Name'];
                $new_field->def = null;
                $new_field->max_length = $field[0]['Size'];
                $new_field->not_null = true;
                $new_field->primary_key = null;
                $new_field->unique_key = null;
                $new_field->multiple_key = null;
                $new_field->numeric = $field[0]['Precision'];
                $new_field->blob = null;
                $new_field->type = $type;
                $new_field->unsigned = null;
                $new_field->zerofill = null;
                $this->col_info[$i] = $new_field;
                $i++;
            }
            $num_rows = 0;
            while ( $row = @sqlsrv_fetch_object($this->result) ) {
                $this->last_result[$num_rows] = $row;
                $num_rows++;
            }

            $this->last_result = $this->fix_results($this->last_result);
            // perform limit
            if (!empty($this->limit)) {
                $this->last_result = array_slice($this->last_result, $this->limit['from'], $this->limit['to']);
                $num_rows = count($this->last_result);
            }

            @sqlsrv_free_stmt($this->result);

            // Log number of rows the query returned
            $this->num_rows = $num_rows;

            // Return number of rows selected
            $return_val = $this->num_rows;
        }
        
                $this->log_query();
        return $return_val;
    }
    
        function log_query($error = null)
        {
            if (!defined('SAVEQUERIES') || !SAVEQUERIES) {
                return; //bail
            }
        
            if (!defined('QUERY_LOG')) {
                $log = ABSPATH . 'wp-content' . DIRECTORY_SEPARATOR . 'queries.log';
            } else {
                $log = QUERY_LOG;
            }
        
            if (!empty($this->queries)) {
                $last_query = end($this->queries);
                if (preg_match( "/^\\s*(insert|delete|update|replace|alter) /i", $last_query[0])) {
                    $result = serialize($this->rows_affected);
                } else {
                    $result = serialize($this->last_result);
                }
                if (is_array($error)) {
                    $error = serialize($error);
                }
                $q = str_replace("\n", ' ', $last_query[0]);
                file_put_contents($log, $q . '|~|' . $result . '|~|' . $error . "\n", FILE_APPEND);
            }
        }

    /**
     * Insert a row into a table.
     *
     * <code>
     * wpdb::insert( 'table', array( 'column' => 'foo', 'field' => 'bar' ) )
     * wpdb::insert( 'table', array( 'column' => 'foo', 'field' => 1337 ), array( '%s', '%d' ) )
     * </code>
     *
     * @since 2.5.0
     * @see wpdb::prepare()
     * @see wpdb::$field_types
     * @see wp_set_wpdb_vars()
     *
     * @param string $table table name
     * @param array $data Data to insert (in column => value pairs). Both $data columns and $data values should be "raw" (neither should be SQL escaped).
     * @param array|string $format Optional. An array of formats to be mapped to each of the value in $data. If string, that format will be used for all of the values in $data.
     *  A format is one of '%d', '%s' (decimal number, string). If omitted, all values in $data will be treated as strings unless otherwise specified in wpdb::$field_types.
     * @return int|false The number of rows inserted, or false on error.
     */
    function insert( $table, $data, $format = null ) {
        return $this->_insert_replace_helper( $table, $data, $format, 'INSERT' );
    }

    /**
     * Replace a row into a table.
     *
     * <code>
     * wpdb::replace( 'table', array( 'column' => 'foo', 'field' => 'bar' ) )
     * wpdb::replace( 'table', array( 'column' => 'foo', 'field' => 1337 ), array( '%s', '%d' ) )
     * </code>
     *
     * @since 3.0.0
     * @see wpdb::prepare()
     * @see wpdb::$field_types
     * @see wp_set_wpdb_vars()
     *
     * @param string $table table name
     * @param array $data Data to insert (in column => value pairs). Both $data columns and $data values should be "raw" (neither should be SQL escaped).
     * @param array|string $format Optional. An array of formats to be mapped to each of the value in $data. If string, that format will be used for all of the values in $data.
     *  A format is one of '%d', '%s' (decimal number, string). If omitted, all values in $data will be treated as strings unless otherwise specified in wpdb::$field_types.
     * @return int|false The number of rows affected, or false on error.
     */
    function replace( $table, $data, $format = null ) {
        return $this->_insert_replace_helper( $table, $data, $format, 'REPLACE' );
    }

    /**
     * Helper function for insert and replace.
     *
     * Runs an insert or replace query based on $type argument.
     *
     * @access private
     * @since 3.0.0
     * @see wpdb::prepare()
     * @see wpdb::$field_types
     * @see wp_set_wpdb_vars()
     *
     * @param string $table table name
     * @param array $data Data to insert (in column => value pairs).  Both $data columns and $data values should be "raw" (neither should be SQL escaped).
     * @param array|string $format Optional. An array of formats to be mapped to each of the value in $data. If string, that format will be used for all of the values in $data.
     *  A format is one of '%d', '%s' (decimal number, string). If omitted, all values in $data will be treated as strings unless otherwise specified in wpdb::$field_types.
     * @return int|false The number of rows affected, or false on error.
     */
    function _insert_replace_helper( $table, $data, $format = null, $type = 'INSERT' ) {
        if ( ! in_array( strtoupper( $type ), array( 'REPLACE', 'INSERT' ) ) )
            return false;
        $formats = $format = (array) $format;
        $fields = array_keys( $data );
        $formatted_fields = array();
        foreach ( $fields as $field ) {
            if ( !empty( $format ) )
                $form = ( $form = array_shift( $formats ) ) ? $form : $format[0];
            elseif ( isset( $this->field_types[$field] ) )
                $form = $this->field_types[$field];
            else
                $form = '%s';
            $formatted_fields[] = $form;
        }
        $sql = "{$type} INTO `$table` (`" . implode( '`,`', $fields ) . "`) VALUES ('" . implode( "','", $formatted_fields ) . "')";
        return $this->query( $this->prepare( $sql, $data ) );
    }

    /**
     * Update a row in the table
     *
     * <code>
     * wpdb::update( 'table', array( 'column' => 'foo', 'field' => 'bar' ), array( 'ID' => 1 ) )
     * wpdb::update( 'table', array( 'column' => 'foo', 'field' => 1337 ), array( 'ID' => 1 ), array( '%s', '%d' ), array( '%d' ) )
     * </code>
     *
     * @since 2.5.0
     * @see wpdb::prepare()
     * @see wpdb::$field_types
     * @see wp_set_wpdb_vars()
     *
     * @param string $table table name
     * @param array $data Data to update (in column => value pairs). Both $data columns and $data values should be "raw" (neither should be SQL escaped).
     * @param array $where A named array of WHERE clauses (in column => value pairs). Multiple clauses will be joined with ANDs. Both $where columns and $where values should be "raw".
     * @param array|string $format Optional. An array of formats to be mapped to each of the values in $data. If string, that format will be used for all of the values in $data.
     *  A format is one of '%d', '%s' (decimal number, string). If omitted, all values in $data will be treated as strings unless otherwise specified in wpdb::$field_types.
     * @param array|string $format_where Optional. An array of formats to be mapped to each of the values in $where. If string, that format will be used for all of the items in $where.  A format is one of '%d', '%s' (decimal number, string).  If omitted, all values in $where will be treated as strings.
     * @return int|false The number of rows updated, or false on error.
     */
    function update( $table, $data, $where, $format = null, $where_format = null ) {
        if ( ! is_array( $data ) || ! is_array( $where ) )
            return false;

        $formats = $format = (array) $format;
        $bits = $wheres = array();
        foreach ( (array) array_keys( $data ) as $field ) {
            if ( !empty( $format ) )
                $form = ( $form = array_shift( $formats ) ) ? $form : $format[0];
            elseif ( isset($this->field_types[$field]) )
                $form = $this->field_types[$field];
            else
                $form = '%s';
            $bits[] = "`$field` = {$form}";
        }

        $where_formats = $where_format = (array) $where_format;
        foreach ( (array) array_keys( $where ) as $field ) {
            if ( !empty( $where_format ) )
                $form = ( $form = array_shift( $where_formats ) ) ? $form : $where_format[0];
            elseif ( isset( $this->field_types[$field] ) )
                $form = $this->field_types[$field];
            else
                $form = '%s';
            $wheres[] = "`$field` = {$form}";
        }

        $sql = "UPDATE `$table` SET " . implode( ', ', $bits ) . ' WHERE ' . implode( ' AND ', $wheres );
        return $this->query( $this->prepare( $sql, array_merge( array_values( $data ), array_values( $where ) ) ) );
    }

    /**
     * Retrieve one variable from the database.
     *
     * Executes a SQL query and returns the value from the SQL result.
     * If the SQL result contains more than one column and/or more than one row, this function returns the value in the column and row specified.
     * If $query is null, this function returns the value in the specified column and row from the previous SQL result.
     *
     * @since 0.71
     *
     * @param string|null $query Optional. SQL query. Defaults to null, use the result from the previous query.
     * @param int $x Optional. Column of value to return.  Indexed from 0.
     * @param int $y Optional. Row of value to return.  Indexed from 0.
     * @return string|null Database query result (as string), or null on failure
     */
    function get_var( $query = null, $x = 0, $y = 0 ) {
        $this->func_call = "\$db->get_var(\"$query\", $x, $y)";
        if ( $query )
            $this->query( $query );

        // Extract var out of cached results based x,y vals
        if ( !empty( $this->last_result[$y] ) ) {
            $values = array_values( get_object_vars( $this->last_result[$y] ) );
        }

        // If there is a value return it else return null
        return ( isset( $values[$x] ) && $values[$x] !== '' ) ? $values[$x] : null;
    }

    /**
     * Retrieve one row from the database.
     *
     * Executes a SQL query and returns the row from the SQL result.
     *
     * @since 0.71
     *
     * @param string|null $query SQL query.
     * @param string $output Optional. one of ARRAY_A | ARRAY_N | OBJECT constants. Return an associative array (column => value, ...),
     *  a numerically indexed array (0 => value, ...) or an object ( ->column = value ), respectively.
     * @param int $y Optional. Row to return. Indexed from 0.
     * @return mixed Database query result in format specifed by $output or null on failure
     */
    function get_row( $query = null, $output = OBJECT, $y = 0 ) {
        $this->func_call = "\$db->get_row(\"$query\",$output,$y)";
        if ( $query )
            $this->query( $query );
        else
            return null;

        if ( !isset( $this->last_result[$y] ) )
            return null;

        if ( $output == OBJECT ) {
            return $this->last_result[$y] ? $this->last_result[$y] : null;
        } elseif ( $output == ARRAY_A ) {
            return $this->last_result[$y] ? get_object_vars( $this->last_result[$y] ) : null;
        } elseif ( $output == ARRAY_N ) {
            return $this->last_result[$y] ? array_values( get_object_vars( $this->last_result[$y] ) ) : null;
        } else {
            $this->print_error(/*WP_I18N_DB_GETROW_ERROR*/" \$db->get_row(string query, output type, int offset) -- Output type must be one of: OBJECT, ARRAY_A, ARRAY_N"/*/WP_I18N_DB_GETROW_ERROR*/);
        }
    }

    /**
     * Retrieve one column from the database.
     *
     * Executes a SQL query and returns the column from the SQL result.
     * If the SQL result contains more than one column, this function returns the column specified.
     * If $query is null, this function returns the specified column from the previous SQL result.
     *
     * @since 0.71
     *
     * @param string|null $query Optional. SQL query. Defaults to previous query.
     * @param int $x Optional. Column to return. Indexed from 0.
     * @return array Database query result. Array indexed from 0 by SQL result row number.
     */
    function get_col( $query = null , $x = 0 ) {
        if ( $query )
            $this->query( $query );

        $new_array = array();
        // Extract the column values
        for ( $i = 0, $j = count( $this->last_result ); $i < $j; $i++ ) {
            $new_array[$i] = $this->get_var( null, $x, $i );
        }
        return $new_array;
    }

    /**
     * Retrieve an entire SQL result set from the database (i.e., many rows)
     *
     * Executes a SQL query and returns the entire SQL result.
     *
     * @since 0.71
     *
     * @param string $query SQL query.
     * @param string $output Optional. Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants. With one of the first three, return an array of rows indexed from 0 by SQL result row number.
     *  Each row is an associative array (column => value, ...), a numerically indexed array (0 => value, ...), or an object. ( ->column = value ), respectively.
     *  With OBJECT_K, return an associative array of row objects keyed by the value of each row's first column's value.  Duplicate keys are discarded.
     * @return mixed Database query results
     */
    function get_results( $query = null, $output = OBJECT ) {
        $this->func_call = "\$db->get_results(\"$query\", $output)";

        if ( $query )
            $this->query( $query );
        else
            return null;

        $new_array = array();
        if ( $output == OBJECT ) {
            // Return an integer-keyed array of row objects
            return $this->last_result;
        } elseif ( $output == OBJECT_K ) {
            // Return an array of row objects with keys from column 1
            // (Duplicates are discarded)
            foreach ( $this->last_result as $row ) {
                $key = array_shift( get_object_vars( $row ) );
                if ( ! isset( $new_array[ $key ] ) )
                    $new_array[ $key ] = $row;
            }
            return $new_array;
        } elseif ( $output == ARRAY_A || $output == ARRAY_N ) {
            // Return an integer-keyed array of...
            if ( $this->last_result ) {
                foreach( (array) $this->last_result as $row ) {
                    if ( $output == ARRAY_N ) {
                        // ...integer-keyed row arrays
                        $new_array[] = array_values( get_object_vars( $row ) );
                    } else {
                        // ...column name-keyed row arrays
                        $new_array[] = get_object_vars( $row );
                    }
                }
            }
            return $new_array;
        }
        return null;
    }

    /**
     * Retrieve column metadata from the last query.
     *
     * @since 0.71
     *
     * @param string $info_type Optional. Type one of name, table, def, max_length, not_null, primary_key, multiple_key, unique_key, numeric, blob, type, unsigned, zerofill
     * @param int $col_offset Optional. 0: col name. 1: which table the col's in. 2: col's max length. 3: if the col is numeric. 4: col's type
     * @return mixed Column Results
     */
    function get_col_info( $info_type = 'name', $col_offset = -1 ) {
        if ( $this->col_info ) {
            if ( $col_offset == -1 ) {
                $i = 0;
                $new_array = array();
                foreach( (array) $this->col_info as $col ) {
                    $new_array[$i] = $col->{$info_type};
                    $i++;
                }
                return $new_array;
            } else {
                return $this->col_info[$col_offset]->{$info_type};
            }
        }
    }

    /**
     * Starts the timer, for debugging purposes.
     *
     * @since 1.5.0
     *
     * @return true
     */
    function timer_start() {
        $mtime            = explode( ' ', microtime() );
        $this->time_start = $mtime[1] + $mtime[0];
        return true;
    }

    /**
     * Stops the debugging timer.
     *
     * @since 1.5.0
     *
     * @return int Total time spent on the query, in milliseconds
     */
    function timer_stop() {
        $mtime      = explode( ' ', microtime() );
        $time_end   = $mtime[1] + $mtime[0];
        $time_total = $time_end - $this->time_start;
        return $time_total;
    }

    /**
     * Wraps errors in a nice header and footer and dies.
     *
     * Will not die if wpdb::$show_errors is true
     *
     * @since 1.5.0
     *
     * @param string $message The Error message
     * @param string $error_code Optional. A Computer readable string to identify the error.
     * @return false|void
     */
    function bail( $message, $error_code = '500' ) {
        if ( !$this->show_errors ) {
            if ( class_exists( 'WP_Error' ) )
                $this->error = new WP_Error($error_code, $message);
            else
                $this->error = $message;
            return false;
        }
        wp_die($message);
    }

    /**
     * Whether MySQL database is at least the required minimum version.
     *
     * @since 2.5.0
     * @uses $wp_version
     * @uses $required_mysql_version
     *
     * @return WP_Error
     */
    function check_database_version() {
        global $wp_version, $required_mysql_version;
        // Make sure the server has the required MySQL version
        //if ( version_compare($this->db_version(), $required_mysql_version, '<') )
            //return new WP_Error('database_version', sprintf( __( '<strong>ERROR</strong>: WordPress %1$s requires MySQL %2$s or higher' ), $wp_version, $required_mysql_version ));
    }

    /**
     * Whether the database supports collation.
     *
     * Called when WordPress is generating the table scheme.
     *
     * @since 2.5.0
     *
     * @return bool True if collation is supported, false if version does not
     */
    function supports_collation() {
        return $this->has_cap( 'collation' );
    }

    /**
     * Determine if a database supports a particular feature
     *
     * @since 2.7
     * @see   wpdb::db_version()
     *
     * @param string $db_cap the feature
     * @return bool
     */
    function has_cap( $db_cap ) {
        $version = $this->db_version();

        switch ( strtolower( $db_cap ) ) {
            case 'collation' :    // @since 2.5.0
            case 'group_concat' : // @since 2.7
            case 'subqueries' :   // @since 2.7
                return version_compare( $version, '4.1', '>=' );
        };

        return false;
    }

    /**
     * Retrieve the name of the function that called wpdb.
     *
     * Searches up the list of functions until it reaches
     * the one that would most logically had called this method.
     *
     * @since 2.5.0
     *
     * @return string The name of the calling function
     */
    function get_caller() {
        $trace  = array_reverse( debug_backtrace() );
        $caller = array();

        foreach ( $trace as $call ) {
            if ( isset( $call['class'] ) && __CLASS__ == $call['class'] )
                continue; // Filter out wpdb calls.
            $caller[] = isset( $call['class'] ) ? "{$call['class']}->{$call['function']}" : $call['function'];
        }

        return join( ', ', $caller );
    }

    /**
     * The database version number.
     *
     * @return false|string false on failure, version number on success
     */
    function db_version() {
        return '5.0';
    }
}
